USE [DTP]
GO

/****** Object:  StoredProcedure [dbo].[GetVehicleCardInfoByID]    Script Date: 11/26/2010 16:47:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[GetPersonCardInfoByID]
	@PersonCardID INTEGER

AS
BEGIN
		SELECT *
		
		FROM t_PersonCards WHERE
		id = @PersonCardID AND Deleted = 0	 
END


GO


